In this article, you will learn how to use the PostgreSQL CASE conditional expression to form conditional queries. The PostgreSQL CASE expression is the same …
Read More »CREATE TABLE AS Statement
This Oracle tutorial explains how to use the Oracle CREATE TABLE AS statement with syntax and examples. In some cases, we can create an exact …
Read More »PostgreSQL If Else Statement
In this tutorial, you will learn how to use the PostgreSQL IF ELSE statements to execute a command based on a specific condition. if-then statement …
Read More »Tables In Oracle Database
In today’s article, we will be examining Tables In Oracle Database, which are the simplest structures in which data is stored. There are 8 types. …
Read More »Use Python In PostgreSQL
I explained in my previous articles that PostgreSQL can be written in more than one language, In this article, I will explain the Python example. …
Read More »Oracle Datafile Autoextend On
In today’s article, we will be learning how to make a Oracle AutoExtend Datafile on. 1. First, we must find a datafile that is not …
Read More »Function Example In PostgreSQL Pl\Perl Language
I mentioned in my previous articles that Postgresql can be written in more than one language, in this article we will be talking about the …
Read More »How To Add The Datafile To Tablespace
In today’s article, we will be discussing the question of how to add a data file to the tablespace in Oracle? 1. We learn columns …
Read More »PostgreSQL Functions
In this section, we will understand the operation of PostgreSQL functions and learn how to use the function. Like operations in programming languages, user-defined operations …
Read More »Renaming And Moving Data Files
In this article presents a brief explanation of how assorted Oracle data files can be renaming and moving to a new location. Data files may …
Read More »